package com.atguigu.gmallpublisher.mapper;


import com.atguigu.gmallpublisher.bean.ProvinceStats;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ProvinceStatsMapper {

    @Select("select province_name , sum(order_amount) order_amount  from dws_user_province_sku_10s where toYYYYMMDD(stt)=#{date} group by province_id ,province_name  ")
    public List<ProvinceStats> selectProvinceStats(int date);
}
